﻿CREATE TABLE [dbo].[Bookings] (
    [BookingId]           INT             IDENTITY (1, 1) NOT NULL,
	[BookingCode]		  VARCHAR(100)		NOT NULL,
    [CustomerId]          INT             NULL,
    [TripCode]            VARCHAR (10)    NOT NULL,
    [AdultNo]             INT             NULL,
    [ChildNo]             INT             NULL,
    [Status]              VARCHAR (10)    NULL,
    [TotalTicketFare]     DECIMAL (18, 2) NOT NULL,
    [PaymentDue]          DATE            NOT NULL,
    [ContactName]         VARCHAR (50)    NOT NULL,
    [ContactNo]           VARCHAR (10)    NOT NULL,
    [ContactEmailAddress] VARCHAR (30)    NOT NULL,
	[BookingDate]          DATE            NOT NULL,
);

